FO_TestsXContainers
This table allows the administrator to indicate container processing details regarding a test order. Each record is defined by a three item value of test code, container code and sub-container code.
The container and sub-container codes will be the same value unless the test code requires multiple containers per collection. In that case the container code must be a code that represents the group of individual sub-container codes and it should be valued the same for each sub-container code. In this case there must be multiple records defined, one for each sub-container code.
This table can also be used to indicate multiple options for containers for a test. For example if Glucose may be performed in either a red top or a green top tube then two records should be created, one for each container code for this test. The default container in this case will be the container code in the FO_TESTS table. The system will indicate container collection options to the User in the order screen by clicking in the container code field then using the drop down arrow.
| Field | Type | Notes |
|---|---|---|
|
TestsXContainer_ID |
int |
ID field, a counter. Unique |
|
TestCode |
varchar(50) |
Enter a valid test code. |
|
ContainerCode |
varchar(50) |
Container code for this test code. The system will search this table by test code and container code at the time of a test order. The container code used for searching is the container code on the order screen. |
|
SubContainerCode |
varchar(50) |
Use the same code as ContainerCode. Must be the same as ContainerCode if the test does not have more than one sub-container for the container code. |
|
ContainerType |
varchar(50) |
Name for the sub-container code. |
|
SpecimenTypeCode |
varchar(50) |
Default specimen code for this test/container pair. Enter a valid specimen code. |
|
LabDept |
varchar(50) |
Lab department. Enter a valid lab department code. |
|
SpotCode |
varchar(50) |
Spot code which is printed on labels. Enter a valid spot code. Indicates the actual testing bench for this test/container pair. |
|
Destination |
varchar(500) |
Enter convention designed codes separated by dashes. Specifies destination related information for this test/container pair. It can be printed on labels. IE: SPIN-PL-Trans This example specifies to spin the tube then protect from light then transport. Also can begin with #MC# to indicate that the microbiology label format should replace the default label format for this testcode/container pair. |
|
LISMethod |
varchar(50) |
Method code for this test. Informational |
|
LISWorksheet |
varchar(50) |
Worksheet name for this test. Informational |
|
LabelGroup |
varchar(50) |
Critical component in container assembly. The system will use this value to include or exclude tests with the same container to a single CID (container id). The system will check the performing lab first, then the container code, then the total volume of all the tests and, finally, the value of this field. This field value can be used to force separation where the first three components are the same. NOLABEL is specifically recognized as no label needs to print. |
|
AliquotLabelContents |
varchar(500) |
Enter a value based on aliquot rule set presented in the label module section. Causes the system to print an aliquot label according to rules. |
|
Storage |
varchar(50) |
Enter a valid storage code as defined in the FO_Types_Storage table. |
|
CollectVolume |
numeric(18, 2) |
Minimum collection volume for this test/container pair. Enter a real number with two decimal places such as 23.45 |
|
ContainerGroup |
varchar(500) |
Informational |
|
AliquoteContainerCodes |
varchar(255) |
Defines the list of aliquot container codes that qualify for this test/container pair. Multidimensional pipe delimited value, with leading and trailing pipes. Enter valid container codes, as defined in the FO_Types_Container table, separated by pipes. |
|
LabelQuantity |
int |
Number of labels that should print for the test/container pair. Enter a valid integer. |
|
DedicateContainer |
varchar(50) |
Determines if this test/container pair should combine with other tests of a like container. Enter Y or N Y = yes, combine with other tests N = no, do not combine with other tests. |
|
LabelFormatID |
varchar(50) |
The format name identifying what label format will be printed for the container label for this test/container pair. Must correspond to an existing format in the text file (format.txt). If populated, this format will override the default format defined in the FO_LabelConfig. This ID will get recorded in FO_Acc_Tubes. This is used for container labels only. **CAUTION** is required in assigning test/container pair specific labels formats. Care must be taken so no container is created that would have multiple conflicting specific label formats. |